package com.tedu.egcqmybatis3.mapper;

import com.tedu.egcqmybatis3.pojo.Customers;
import com.tedu.egcqmybatis3.pojo.CustomersVO1;
import com.tedu.egcqmybatis3.pojo.CustomersVO2;
import com.tedu.egcqmybatis3.pojo.CustomersVO3;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;


@Mapper
public interface CustomersMapper {

    int insert(Customers customers);

    CustomersVO1 selectCustomersVO1ById(String custId);

    List<CustomersVO2> selectCustomersVO2ByCity(String city);

    List<CustomersVO3> selectCustomersAndOrders(String custId);

}
